home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / oracl / mar97 / koopf105.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  15.8 KB  |  633x189  |  4-bit (15 colors)
   ocr: FIGURE 5: The nonunique test. Clustering for the nonunique index drops significantly, whereas clustering for the primary key rises. blkixchk.sql Alloc, B leaf Avg. Loaf Blocks Avg. Data Blocks Distinct Number Pct, Cluster Index Uniqueness Blocks level Blocks per Key per Key Keys off Rows Clustering for Rows Estimate Statistics: KOCPML.IESTI_PK UNIQUE 775 2 736 1 1 78,656 79,167 77,964 98.48 KOCPMITESTLPLAUDLOT NONUNIQUE 415 2 402 5 5 68 79,167 1,496 1.89 Compute Statistics: IKCOPM1.TESTI_PK UNIQUE 775 2 734 1 1 79,112 79,112 78,398 99.10 ROOMIESTL/LAUULOI NONUNQUE 415 2 399 5 17 68 79,112 1,18 ...